Programming Forums > Web Development and Design > PHP

squishiful · Aug 23rd, 2005, 5:24 PM

Is there a way to check if a cell in mysql ends with a certain string something like:

$sql = "delete from table where name endsWith 'hn'";

though that code won't work is there anyway to do that? Thanx!

squishiful · Aug 23rd, 2005, 5:43 PM

nvm I figured it out
here:

(Toggle Plain Text)

$sql = "delete from examples where right(name, 2) = 'hn'

Lich · Aug 23rd, 2005, 10:16 PM

Good piece of code, I was going to suggest using php to select all where it would contain hn, run through each one, do a substring on it, check, if it checks out delete it. Your method is much nicer, I guess I gotta brush up on my SQL a bit

Infinite Recursion · Aug 24th, 2005, 7:23 AM

for an alternative, you may also be able to do something like this:

$sql = "delete from table where name like '%hn'";

Aug 23rd, 2005, 5:24 PM	#1
squishiful Programmer Join Date: Jun 2005 Location: Amittyville Posts: 60 Rep Power: 4	getting a mysql entry that has a cell that ends with... Is there a way to check if a cell in mysql ends with a certain string something like: (Toggle Plain Text) $sql = "delete from table where name endsWith 'hn'"; $sql = "delete from table where name endsWith 'hn'"; though that code won't work is there anyway to do that? Thanx! __________________ I steal hippos...

Aug 23rd, 2005, 5:43 PM	#2
squishiful Programmer Join Date: Jun 2005 Location: Amittyville Posts: 60 Rep Power: 4	nvm I figured it out here: (Toggle Plain Text) $sql = "delete from examples where right(name, 2) = 'hn' $sql = "delete from examples where right(name, 2) = 'hn' __________________ I steal hippos...

Aug 23rd, 2005, 10:16 PM	#3
Lich Professional Programmer Join Date: May 2005 Location: Detroit Posts: 254 Rep Power: 4	Good piece of code, I was going to suggest using php to select all where it would contain hn, run through each one, do a substring on it, check, if it checks out delete it. Your method is much nicer, I guess I gotta brush up on my SQL a bit __________________ --John Cruz Web Developer www.cruzweb.net

Aug 24th, 2005, 7:23 AM	#4
Infinite Recursion Programming Guru Join Date: Jul 2004 Location: United States Posts: 3,467 Rep Power: 8	for an alternative, you may also be able to do something like this: $sql = "delete from table where name like '%hn'"; __________________ http://jasonpowers.net "There are a thousand hacking at the branches of evil to one who is striking at the root."

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Programming Forums > Web Development and Design > PHP

getting a mysql entry that has a cell that ends with...