MySQL Search Tip

So I haven’t written anything in ages, and wanted to put up something to say that i am still kicking. Today i had one of those duh moments, when you stumble upon a feature you never new about. This one is a real duh since its so obvious.

So I was moving a site with dynamic content to a new url, and was searching the DB for any direct links to the old url, so i was building custom Sql queries using MATCH AGAINST and LIKE, to find the search string in th Db tables fields. Well as i was about to use PhpMyAdmin to execute my query i realised there was a search tab, and low and behold it does what i want with out needing to write my own query, DUH.

Thats Al, till i feel like writing again