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:

[sql]DELETE FROM template WHERE template LIKE (prefix%)[/sql]

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:
[sql]
DELETE FROM template WHERE template LIKE "prefix%"
[/sql]
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