Gossamer Forum
(Advanced Search)
for
Jan 28, 2003, 2:26 AM
Andy
Veteran / Moderator (18441 posts)
Andy's avatar
Jan 28, 2003, 2:26 AM
Views: 4631
Shortcut
Quote Reply
LIKE %%
I'm trying to figure out how to use the MySQL's LIKE option. I have a variable in the SQL database, like;

23 54 23 44 54 23 44

Now, I want to run something like;

SELECT * FROM lsql_Adverts WHERE Field LIKLE '% 54 %'

I've been scanning through the documents, but didn't see anything. Maybe GT should add an internal search engine of the documents for us developers Smile

Thanks to anyone who can help.

BTW: I did search the forum, but didn't yeild much, as I really need to do a case sensative search, but GForum doesnt let you Frown)

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Subject Author Views Date
Thread LIKE %% Andy 4631 Jan 28, 2003, 2:26 AM
Thread Re: [Andy] LIKE %% 		Paul 4458 Jan 28, 2003, 2:29 AM
Thread Re: [Paul] LIKE %% 		Andy 4461 Jan 28, 2003, 2:32 AM
Post Re: [Andy] LIKE %% 		yogi 4453 Jan 28, 2003, 2:39 AM
Post Re: [Andy] LIKE %% 		Paul 4438 Jan 28, 2003, 2:54 AM
Thread Re: [Andy] LIKE %% 		pugdog 4456 Jan 30, 2003, 11:49 AM
Thread Re: [pugdog] LIKE %% 		Andy 4379 May 8, 2003, 3:51 AM
Thread Re: [Andy] LIKE %% 		Mel_g 4339 May 8, 2003, 12:46 PM
Thread Re: [Mel_g] LIKE %% 		Paul 4352 May 8, 2003, 1:41 PM
Post Re: [Paul] LIKE %% 		Mel_g 4325 May 8, 2003, 2:49 PM
Post Re: [Andy] LIKE %% 		pugdog 4310 May 9, 2003, 12:45 PM