MYSQL - searching strings within a select

Question

I want to be able to search a field in the database and see if the "changed from" and "to" values are different(the values are stored within a string in a single field).

Here is an example of what the string in the field looks like

Instance Person(34) modified by 1.
Field phone_number changed from "123" to "123".
Current field values are:
    first_name => "alex"
    last_name => "Handley"

In this example they are the same so would not be returned.

is it possible to do this ?

Alex

This data should be stored in separate fields in the database, so that you can write easier queries. eg. WHERE changed_From <> changed_to — a'r
– a'r, Commented Aug 17, 2010 at 17:38

Borealid · Accepted Answer · 2010-08-17 17:34:59Z

2

This is really a job for a regular expression, not a database query.

You could do it with a stored procedure which makes a query, chops up the result, and compares the two parts. But, again, this type of logic belongs at the application layer - either beforehand, storing the parts of the string you'll need to compare separately, or afterwards, extracting the useful info from the single database column.

answered Aug 17, 2010 at 17:34

Borealid

99.3k9 gold badges111 silver badges123 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Seth · Accepted Answer · 2010-08-17 17:37:34Z

1

MySQL has pretty nice regular expression support. (It's also fast; I've found that REGEXP is often faster than LIKE).

I don't believe that it has back reference support, so it would be difficult to compare in a single query. You might be able to do it with a clever join or a stored procedure.

answered Aug 17, 2010 at 17:37

Seth

46.8k10 gold badges87 silver badges123 bronze badges

Collectives™ on Stack Overflow

MYSQL - searching strings within a select

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related