LIKE operator

[jamkelvl]

I am storing a serialized array in a column assigned_to the data looks like...

 

a:1:{i:0;s:2:"LS";}

 

What I want to do is look thru all the crazy data from the serialized array looking for "Unassigned" and "UN" all I've thought to try is:

 

SELECT * FROM table WHERE assigned_to LIKE 'un%' ***EDIT**** <----- this works in phpmyadmin not in my php select...

 

<?php
$select = "SELECT * FROM jobs WHERE assigned_to like = '%u%'";
?>

 

but have had no results come up in php

 

how can I do this (these select statements are in php so maybe I unserialize first or something?)

[lampstax]

You have an extra = there.

 

It should be

 

<?php

$select = "SELECT * FROM jobs WHERE assigned_to like '%u%'";

?>

[Maq]

SELECT * FROM table WHERE assigned_to LIKE 'un%' ***EDIT****

 

Are you sure they're not different...?

 

http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html#operator_like