Query for deleting templates which have a prefix "X"

[geniuscrew]

is it possible to do this? thanks

[N!ck]

i know you can do instr(), such as:

DELETE FROM table WHERE INSTR(field, 'string')

don't hold me to that, i might have the parameters backwards.

anyhow, check out the manual at http://www.mysql.com/

[Xenon]

hmm i think this one:

DELETE FROM template WHERE template LIKE (prefix%)

but not 100% sure, use it on your own risk ;)

[N!ck]

i'm going to go out on a limb and say that Xenon is definitely correct...try it on a test table first though.

[filburt1]

I think you need quotes...or if you don't you probably should anyway:

DELETE FROM template WHERE template LIKE "prefix%"

For example:

mysql> select userid,username from user where username like "filburt%";
+--------+----------+
| userid | username |
+--------+----------+
| 1 | filburt1 |
+--------+----------+
1 row in set (0.00 sec)

[Xenon]

yes filburt is right, quotes are needed

[geniuscrew]

Ahh OK - thanks everyone!

[geniuscrew]

Query with quotes don't work ppl

[Xenon]

use singelquotes :)

[geniuscrew]

Still not working :( - it says the query is a success though

[Xenon]

sorry, my fault, change the "template like" into "title like" ^^

[geniuscrew]

Oh thankyou - Xenon

Again :P

[Xenon]

welcome :)

[gmarik]

Thanks, Fil.