NYCPHP Meetup

NYPHP.org

[nycphp-talk] MySQL query question

DeWitt, Michael mjdewitt at alexcommgrp.com
Tue Nov 16 11:08:18 EST 2004


Does anyone know if there is a way to write a query in a v3 engine to do a
query comparing two columns using like?

I would like to count all rows where the last name appears in the company
name.

In sql server a query like this works:

select count(*) from table where company like rtrim(last_name)+'%'

Thanks in advance.

Mike




More information about the talk mailing list