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)
If you are using EMS SQL Manager for MySQL, you can use RegEx to filter data.

```
SELECT col 
FROM tbl
WHERE col REGEXP '^[[:alpha:]]{2}[[:digit:]]{1}$'

```

RegEx:

```
^[[:alpha:]]{2}[[:digit:]]{1}$

```

`^` = starts with

`[[:alpha:]]` = alphabet

`[[:digit:]]` = numbers

`{n}` = exactly n instances of

Hope this helps.