Question: I don't know what this is called, but it is something like syncing android application and a Web server. Examples are RSS Feeds and Weather Forecast

Does anyone know the concept behind developing application? I mean how do you sync the Android phone with a web server. Is there any programming needed in the server side and the client side(Android)

Are there any programming books that tackles this subject? Thanks.

Answer: 
Just to state the accepted answer explicitly:

```
SELECT myCol 
FROM myTable 
WHERE SUBSTRING(myCol, 1 , 1) BETWEEN 'A' AND 'Z' AND
SUBSTRING(myCol, 2 , 1) BETWEEN 'A' AND 'Z' AND
SUBSTRING(myCol, 3 , 1) BETWEEN '0' AND '9'

```

(mixture of Ken's answer and Andriy's suggestion)
Try this -

```
SELECT myCol FROM myTable WHERE myCol REGEXP '[[:alpha:]]{2}[[:digit:]]{1}'

```

<http://dev.mysql.com/doc/refman/5.1/en/regexp.html>