How do I word this MySQL command correctly please?

DELETE all instances FROM bnt_ships WHERE ship_name contains the word xenobe

PHP:

 

DELETE FROM bnt_ships WHERE ship_name LIKE '%xenobe%'

Code (sql):

 

DELETE FROM bnt_ships WHERE ship_name LIKE '% xenobe %'

Code (markup):

Or this if you want to delete records with xenobe only instead of deleting sdhoxenobesldf

 

Thanks. I think the first option is more what I need.

 

But it doesn't recognise the word if it has punctuation. Not that it matters in this case but you could use:

DELETE FROM bnt_ships WHERE MATCH (ship_name) AGAINST ('xenobe')

Code (markup):

 

Actually, that might matter. Every record that needs deleting begins Xenobe-

 

If they begin with an exact phrase, don't use the % at the front.

For example, %xenobe% would match
rexenobe
xenober
xenobes

whereas xenobe-% would not match noxenobe but would match xenobe-10, xenobe-fred, whatever. % is a wildcard.