Search

[pcs800]

I am so unfamiliar with mysql, but i like this tool because i have gotten farther with it than any other.

Can someone tell me how to do a search fopr a certain word or entry in a table so i can delete it?

[peterlaursen]

You will need to write a little SQL.

You can

Code:

SELECT from `the_table` where `the_column` like '%the_phrase_to_search%'

if 'the_phrase_to_search' is 'cs' then it will find 'pcs800', pcs900', 'qcs1111' .. any string containming the substring 'cs'.  the ” % ” character is a SQL 'wildcard'

There is an option to paste a SELECT SQL statement template from the table context menu

If you want to search in more columns just use logical OR

Code:

SELECT from `the_table` where `the_first_column` like '%the_phrase_to_search%' OR `the_second_column` like '%the_phrase_to_search%'

'quick filters' are coming soon (in 5.3 or 5.31 probably), so that you can just right-click a cell and select a search option from here.

[Author]

Posts