Entry

How can I search a database for part of a string?

How do I use LIKE in a query?

What is the wildcard symbol in SQL?

How to speed up a like??

How to create an query that uses like and or that doesn't take forever to return reuslts?

How to create an or query with using a like?

Jun 27th, 1999 17:27
Nathan Wallace, Web Boy, Ben Udall, Adam Whitehead, Nick Talbott

To do substring searches you can use:
$result = mysql_query("
    select * from schools where code LIKE '%$search%'");
NOTE: % is the SQL "wildcard" symbol
This will find all rows in the table schools where the column code
contains the string stored in the variable $search.
Careful though, LIKE is quite slow .. and LIKE %abc% queries cannot be
indexed with MySQL.