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

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 )

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!

If you are trying to figure out "LIKE" then you should be searching at the mysql site, not the GT docs.

Are you looking for how to use it or how to write the GT::SQL equiv?

I know how to use LIKE, but I need the GT::SQL equivelant...

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!

Have a look in the documentation for GT::SQL::Condition.

Ivan
-----
Iyengar Yoga Resources / GT Plugins

Well be more accurate in your questions because you said:

The mass mailer .pm uses "%_%" with like in several places, you may get an idea of how to do it with complex conditions by looking at that .pm and then setting your debug level 1 and checking your error logs for what the actual submitted query is.


PUGDOG� Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.

I've just got back to looking into this. I am now using;

my $cond = new GT::SQL::Condition;

if ($query) {
$cond->add(Article => Like => "%$query%");
}

The thing is, does anyone know if you can use multiple fields to search? For example, the above would search the 'Article' field to see if the words exist, but I want it to search both the Article and Title fields.

does anyone have any experience with this?

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!

It should be

$cond->add('Field','LIKE',"%$query%");
Mel Goulet
Developer - Gossamer Threads, Inc.

Andy's code already does that except using => which prevents you having to quote so much.

I've found that doing it with the => 's doesn't always work.
Mel Goulet
Developer - Gossamer Threads, Inc.

I don't remember exactly, but my alpha_bar plugin uses "LIKE" to allow for first letter and start of word searches. Might give you some clues.


PUGDOG� Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.