How to remove from the table all rows starting at zero?


Warning: count(): Parameter must be an array or an object that implements Countable in /home/styllloz/public_html/qa-theme/donut-theme/qa-donut-layer.php on line 274
0 like 0 dislike
15 views
Query against the DB via PMA: DELETE FROM usrcfg WHERE idname LIKE "^[0]"; that would remove all the entries in the column idname, starting with "0", the query runs without errors, but the rows with zero are not deleted. Where is the error?
An example of the entries in column idname:
0-username1
1-username1
0-username2
3-username1
0-username3
by | 15 views

2 Answers

0 like 0 dislike
DELETE FROM usrcfg WHERE idname LIKE '0%';
by
0 like 0 dislike
not like regex
by

Related questions

0 like 0 dislike
1 answer
0 like 0 dislike
4 answers
0 like 0 dislike
1 answer
0 like 0 dislike
2 answers
110,608 questions
257,187 answers
0 comments
40,796 users