Mysql strategy

If I have to perform 30 LIKE searches for different keywords in a
varchar field, which strategy would be recommended:
1) 30 searches, one for each keyword
2) To select the varchar field from all the rows, and search through
them with php's array functions?

There are about 500 rows in the table, and growing. The mysql server
is on localhost, and the machine is a dedicated server running RHEL.
It's not my machine, so I'd like to be responsible with resources, as
much as I can be. Thanks in advance for any advice.

Dotan Cohen

http://what-is-what.com/what_is/ajax.html
.

Relevant Pages

  • Searching for misspelled keywords?
    ... I'm using SQL queries with LIKE operator to search for keywordin a ... VARCHAR field of a table. ... for alternate spellings incase of any misspellings, ... Please note that I need to search for one or more keywords in VARCHAR fields ...
    (microsoft.public.sqlserver.programming)
  • Re: [PHP] Mysql strategy
    ... > If I have to perform 30 LIKE searches for different keywords in a ... > 2) To select the varchar field from all the rows, ... and the machine is a dedicated server running RHEL. ... solution of MySQL, only yours is a lot slower... ...
    (php.general)
  • Re: [PHP] Mysql strategy
    ... On 13/11/06, Chris wrote: ... > If I have to perform 30 LIKE searches for different keywords in a ... > 2) To select the varchar field from all the rows, ... This is the makeLink function in another ...
    (php.general)
  • Re: [PHP] Mysql strategy
    ... > If I have to perform 30 LIKE searches for different keywords in a ... > 2) To select the varchar field from all the rows, ... If you are worried about the speed of this query I'd suggest rethinking ... your database structure. ...
    (php.general)