best regards
Robb Kerr wrote:
On Tue, 28 Oct 2003 02:09:06 +0000, David Otton wrote:
Personally, I'd normalize that into a keyword table, a record table and a joining table.
However, the SQL keyword you're looking for is LIKE
WHERE field LIKE '%$variable%'
I agree. I'd structure the data quite differently. But, I've got the data from a client and at this point I don't have the authority to restructure the database. Thanx for the tip on the LIKE command.
Robb
-- Raditha Dissanayake. ------------------------------------------------------------------------ http://www.radinks.com/sftp/ | http://www.raditha/megaupload/ Lean and mean Secure FTP applet with | Mega Upload - PHP file uploader Graphical User Inteface. Just 150 KB | with progress bar.
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php